SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345318 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345318 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029641,938102,127065,813293,136266,844210,276952,587215,126600,632527,809833,69103,29850,142417,578146,370573,532673,959708,700002,321587,946790,75904,185441,357336,952475,145128,792942,351497,1035515,365105,905165,324763,651876,896191,15939,829984,333174,17859,71548,481028,729951,300178,892961,760809,691285,782512,265998,924918,457320,296985,1010104,968870,783121,788965,305666,58088,664034,405850,201467,138148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]