SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340474 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340474 [ RunTime:0.002955s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (57197,105683,619618,776521,939840,924759,293445,149029,283711,609775,92191,759404,330587,544476,145047,269923,586490,86763,312496,884048,874223,439609,292814,119825,18034,13544,394952,88362,845113,964014,806594,699764,199666,498339,822087,653778,447930,411919,358046,468781,847832,135532,227341,554342,995517,408476,2824,991140,767998,596506,831199,1040677,333308,534131,379118,599963,743562,533481,67167,169671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]