SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481615 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481615 [ RunTime:0.002298s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698202,463572,167290,715483,867039,819112,140922,314760,15638,96097,395543,317926,146782,284915,849746,421830,58004,148900,533317,24648,197764,82656,481094,507954,159831,439618,582545,1046910,593766,385883,150441,832379,443645,569378,817122,914886,736868,720697,247667,570388,885788,328132,941294,82617,73614,57735,991167,697475,1003929,789323,418860,1032053,240504,955130,450462,25729,976641,63918,233866,995344) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001263s ]