SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 29151 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 29151 [ RunTime:0.002310s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (461178,625957,1029826,1039826,635834,723496,897229,808702,225618,814096,290855,733794,575983,896530,659772,510837,1032762,455118,349781,334282,842929,165027,1006550,242256,786062,628291,134969,204142,413109,250330,400985,992053,248624,52173,970898,603262,984235,616443,600311,799007,683554,619680,72915,1003502,530778,642382,380022,620074,251374,888749,842476,429841,403775,120701,575958,1048164,1009768,504503,84602,565231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 29151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 29151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]