SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450781 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450781 [ RunTime:0.002752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030134,622730,244423,278695,778256,92668,419671,938199,774765,229044,489693,202342,654613,863741,322965,303653,98561,403550,821867,10981,86855,794569,902107,738943,928090,163460,130767,539273,252990,700896,131458,65876,655130,396741,435828,1014773,813349,606184,89884,428201,57621,682572,281662,818238,434146,498219,121805,232721,123974,554778,525290,35789,863455,826422,337174,134935,74528,220157,550125,415917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000619s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002595s ]