SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002665s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261243 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261243 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540850,578249,661506,428392,950390,966187,814922,772771,174880,391486,622083,294277,250815,113719,846262,507631,781670,720559,637395,352571,419335,622135,99636,326893,619123,910601,209371,108634,532343,621502,187517,547339,41990,374075,6207,899940,561425,537410,246923,456732,744546,1003735,465013,180108,215222,529691,424042,444384,977062,11357,725060,196876,59011,1028950,125659,1001727,823135,339256,49050,268861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]