SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45164 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45164 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664091,20416,800172,1013124,778418,476256,786753,634190,413961,817461,141866,968107,71668,622272,1034289,177721,614115,92659,985916,81400,936732,839020,919386,21654,472224,688117,964210,911339,232626,15519,191353,595656,993478,729922,739484,220224,732877,265706,263294,811334,405258,487963,640307,715609,158014,147803,101777,734103,853751,556714,160535,616076,564524,50590,200931,100639,791604,908902,703727,708513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45164 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45164 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000774s ]