SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001601s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 572010 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 572010 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285549,86795,385247,391939,82897,40887,890116,1031471,458155,529516,507294,139121,874815,555132,174962,215682,53372,747134,211109,4044,789013,192103,1035811,908831,924878,641990,533431,1040612,774927,838539,1048608,595581,120922,443931,721665,845598,257746,151211,486143,569683,242680,462716,418459,345787,203535,232872,313075,591607,454210,833752,27055,666164,985497,642952,653897,832877,321470,788512,573210,825961) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 572010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 572010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]