SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 620513 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 620513 [ RunTime:0.002207s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313004,740991,669265,765629,243696,934367,553595,573159,639804,22195,35086,516226,752408,224504,580103,492876,883442,22710,24680,81982,224813,2995,431269,252227,283948,419436,899768,752240,454693,751284,397934,562161,293551,756752,234736,368339,52141,261218,414539,135168,726685,876784,191469,309227,464042,920192,1013186,972074,397527,1009036,150746,897281,502573,904730,1023486,938920,740512,141339,551204,610729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 620513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 620513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]