SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017588 LIMIT 1 [ RunTime:0.001018s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017588 [ RunTime:0.003950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (959500,258325,834465,448730,70724,97844,361282,119656,488320,849637,5066,655687,648488,413721,817042,919424,513122,217679,756472,333894,379230,167024,660218,206978,958632,432824,305725,249390,946269,673368,425151,687262,418466,924648,872706,526137,773882,485963,666839,995825,270278,992993,239588,548439,909464,554315,293172,286412,526509,717113,35357,209523,364070,729321,987939,150679,83109,1024139,1001805,934997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017588 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017588 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]