SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290328 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290328 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508689,244033,874967,289500,1003665,151965,425126,874990,475917,382386,195124,674445,536872,674021,411074,468071,226116,828404,519304,236452,82610,315426,897132,315825,1025256,901700,602516,938425,405062,18465,882344,904924,486063,670330,104436,121651,498624,1045080,21621,582095,631994,74486,570651,131824,357190,748140,466132,809001,669556,581482,100339,595053,887405,581633,481000,533888,441827,772912,1043300,606752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]