SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547509 LIMIT 1 [ RunTime:0.000459s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547509 [ RunTime:0.001506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266281,326266,269866,856762,317244,172014,443089,310787,980502,666336,57171,556133,968255,568148,816624,146263,31990,443717,235089,790720,468888,772485,636533,880501,598972,374827,27651,395624,565397,584205,1032174,187844,370468,437639,662149,308776,518015,215641,762605,670286,173855,31860,180949,805649,732593,746098,272894,497687,388441,771848,755523,223167,40780,484858,245271,747913,697331,303664,399540,182809) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]