SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540134 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540134 [ RunTime:0.002290s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266350,969299,276827,823061,749125,703780,984764,730363,323513,939474,378184,287696,265110,426889,601441,861470,468934,41381,1003073,342504,460633,572945,975593,946817,1001862,990754,675768,361560,991213,245038,267923,780900,1031502,809915,922767,507142,1021385,725512,636052,567317,801666,763271,828401,397081,929214,761252,178748,771876,827622,457821,736328,575528,334548,183247,967738,554269,376135,852295,521853,533889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540134 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540134 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]