SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417875 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417875 [ RunTime:0.006642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (948595,598816,508613,617416,584378,936386,735458,397563,1015784,422457,12680,635695,211337,356110,1004228,265629,87662,861606,661928,651656,226850,1029835,964215,1029782,264609,1000160,607442,190983,378329,972416,182223,376317,192302,295544,212849,219784,690824,677840,310445,418498,69943,962947,93949,522903,303112,980378,529281,468193,205526,442942,281615,841264,299022,543721,322854,53339,547417,575734,102567,776672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]