SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433802 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433802 [ RunTime:0.004008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317612,633039,430460,656189,332825,777238,1020066,442516,217408,841797,989903,664482,197560,331423,756344,1015228,329714,259197,808764,573714,64698,453664,255283,197341,797016,7619,914569,995204,992180,253031,18074,147176,1046911,1029861,43304,144117,268454,189290,515453,224146,526163,690464,42646,75774,579818,565678,959408,375553,707045,265749,832617,28791,748136,633441,171370,476880,939479,455373,153524,1001342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433802 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433802 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000893s ]