SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521683 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521683 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (680801,974692,773023,121200,167095,726391,906370,648455,516463,324772,693385,892955,803552,879847,919047,701423,175598,617628,1041072,702989,114334,2933,209730,1005546,294933,338670,232180,590749,712293,398421,133894,135764,852104,824068,568021,788867,44034,443382,485372,688425,795755,588570,327498,569886,491147,825420,475142,211890,454323,1016132,49390,285113,790758,348340,242378,696357,109882,277467,958000,1002732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]