SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106316 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106316 [ RunTime:0.001595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500717,599703,841014,895067,326778,839275,373970,47392,649683,1015656,979608,1012105,20965,263941,210860,972334,59464,573020,103291,493937,276277,1039647,715092,1015414,439730,136976,785596,342198,489816,981390,969410,117389,830657,435536,57401,442645,656183,465016,184785,880602,248728,509001,211144,561988,220376,329745,777386,568731,667168,521405,566104,179884,365711,231301,835834,383811,684337,927221,182608,960930) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]