SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001442s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43070 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43070 [ RunTime:0.001511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840031,1045895,866878,281780,538498,516593,849422,113706,901831,129809,288594,479614,985854,328748,697139,1016449,766539,913813,762045,462183,175294,933227,152806,333514,336455,842645,373385,1010396,218112,847878,914059,782119,486491,256734,674517,697786,21069,504355,971297,655914,402727,337670,788869,344784,724557,23710,813958,515563,831231,478695,755122,832158,180404,316162,345434,1007187,1038557,504522,269494,201700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000710s ]