SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001740s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400699 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400699 [ RunTime:0.003226s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042189,331310,860721,695204,637543,319091,933882,403845,705117,29666,184181,937647,62929,1025939,815943,847332,135250,637777,385560,5484,293585,655251,221440,287351,952119,459786,605481,980736,487275,918312,333084,522876,1037737,583913,353244,419962,495093,836781,556772,616954,769403,388582,641613,601260,745336,677843,100147,233494,202784,201872,163124,293790,323651,688075,304278,599314,627579,325759,46550,1018722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000752s ]