SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003923s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017542 LIMIT 1 [ RunTime:0.001373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017542 [ RunTime:0.005401s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006821,508113,92294,429734,859008,957923,1037035,213025,703466,261236,396862,318141,921827,403443,823869,856522,374748,564690,639313,845503,811008,557540,361975,465027,359347,511033,697236,776497,914291,1025762,789221,594283,264845,367505,158071,609147,907340,435689,964169,120680,173063,369000,622951,274913,688599,121112,388988,478901,616133,801557,523732,884018,276971,990050,964107,650998,539067,661738,172393,399703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017542 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017542 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000748s ]