SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028109 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028109 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (708209,380535,323060,119993,892252,888704,748793,861513,200601,203078,165850,118703,507253,433620,366146,141889,285589,372408,64361,1019709,812566,587356,237173,980821,500770,522185,52448,419348,406026,107753,1037260,898370,872427,592771,317244,1046966,673189,988239,842678,951460,962037,99946,200053,654672,662681,772197,818022,320263,648353,368811,717680,533596,577450,176448,534558,131328,386706,202808,908158,797677) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]