SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544052 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544052 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261247,798756,200861,257934,763802,718066,882176,77604,210775,30307,550651,144168,786436,772910,212075,117581,557298,727753,292726,573959,1008945,529329,933164,866230,1025279,742588,624740,600974,445160,742009,219180,120510,244796,713729,995803,587999,198907,274090,533520,737753,996613,900209,924194,839496,896069,741282,26145,188188,608156,907025,585848,706401,519712,829340,58768,1023563,978586,950239,119670,789259) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]