SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022952 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022952 [ RunTime:0.002402s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (742374,565267,561687,11960,17571,633007,644740,578616,711076,966652,114538,1027944,254168,635967,766816,36000,451973,300857,799660,440033,686368,329467,614594,623367,487091,717467,813066,58516,101160,785703,868177,589399,507189,270266,710090,140695,750373,546693,1010008,270678,600666,829953,638035,485801,225627,333139,795616,243562,289750,375928,433990,812014,654758,710022,108966,479879,230149,33963,988839,329703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022952 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022952 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]