SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341548 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341548 [ RunTime:0.002533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793226,479169,1007047,1003959,1034739,183854,726697,579217,722380,515337,135047,976732,926977,196756,577421,652915,742567,1006423,355522,582158,942480,116004,307852,42153,1036848,466553,515845,866356,836168,571586,425563,929143,265108,984694,663660,47494,805325,376535,909307,1043386,683378,259712,700276,643214,585863,896754,195775,173774,334718,766227,310502,665050,878817,415048,1581,116120,975119,1022117,244080,178282) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341548 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000642s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341548 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]