SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418912 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418912 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (732445,622726,832751,479835,392026,568371,112828,94312,8165,974615,918908,1025460,928437,914510,703254,696715,189782,916091,959677,424977,941929,898585,1043872,1048227,345278,451465,1029605,627915,916853,147680,1009550,720525,867023,1015165,389418,265745,270120,856236,1020693,234429,450801,324975,315260,367128,272830,210442,694103,148417,793360,440464,676125,692050,695788,1009078,649406,303018,216460,88319,871436,529320) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001606s ]