SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037713 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037713 [ RunTime:0.003019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593410,560910,52305,599808,427563,54360,461577,1018405,397295,631096,819153,365626,405215,680852,920291,326547,460684,124906,781359,418580,327574,869859,313045,420269,414445,1119,459198,505465,43025,169657,863411,773289,214248,203379,639699,625481,774126,174549,184089,709394,794868,568194,674430,485346,28221,811206,988262,748615,1000873,661863,754734,911914,397388,675307,655671,640015,600320,266194,9919,870124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]