SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001734s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432591 LIMIT 1 [ RunTime:0.000466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432591 [ RunTime:0.004070s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262712,317822,191858,371876,205170,421530,533398,790556,815969,376267,969378,29330,362803,1030355,336623,811624,415062,65437,86087,1002425,52369,785627,679636,866613,766687,268934,786915,839761,331724,234785,546453,166297,482993,494347,46464,490566,70379,633595,803497,666944,655000,829135,405714,573038,603505,53063,561062,483499,453991,1033227,930611,818018,644249,846505,49586,948222,938458,421201,386985,86616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]