SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 121312 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 121312 [ RunTime:0.001862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250040,60053,705231,42789,991386,98500,385503,1043496,955716,790098,246847,379866,257320,848888,314319,844365,1041550,654032,666835,137633,506911,362191,10781,759458,15036,961633,829776,273856,607367,544336,595143,618751,852708,676694,915568,243095,894957,383821,1000007,61404,704578,159625,11401,638472,839992,403623,859191,327721,72593,263053,131923,276806,913968,1018393,876805,60493,508104,368459,498405,32812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 121312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000601s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 121312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]