SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506258 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506258 [ RunTime:0.002356s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (919618,450732,920339,383865,59336,391057,822670,872472,940828,450526,546760,450315,1005926,856553,579173,229401,802800,235537,156572,692750,259789,419076,199685,751721,110997,668348,113661,682907,873537,852482,104160,838458,292447,341858,1012340,326044,779116,966485,133962,522891,281472,270086,112644,20559,211617,326903,710049,1000720,973530,305626,802865,930264,845785,101406,536974,607825,662421,35279,957488,557170) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506258 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506258 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]