SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 255610 LIMIT 1 [ RunTime:0.002778s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 255610 [ RunTime:0.003412s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438530,394322,199310,869703,825875,98797,986257,668505,876294,925250,591960,519550,410429,650683,462124,310287,324873,200816,155465,680167,529434,359545,796564,562993,736553,690265,568947,495519,534995,296785,509335,500578,172716,572647,408804,807344,766976,444012,423660,4741,1021464,643673,696089,721501,486904,616319,421213,742467,229490,48273,1042096,527948,362771,948051,881518,494617,835063,989599,545203,233102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 255610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003844s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 255610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001054s ]