SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542046 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542046 [ RunTime:0.004196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044734,785375,548796,143985,819838,150781,805799,678805,145565,230913,730751,551545,687051,720794,166875,593357,477984,449600,868830,876671,636305,321500,529571,564363,146127,19929,496449,349038,282542,724098,12384,929263,200077,776999,897903,571889,795490,983452,643804,96465,573841,94022,166112,46399,582802,308744,476798,147340,604674,879873,360919,27659,151561,218287,347817,752400,92465,492001,98394,17637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000686s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]