SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001905s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497249 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497249 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (476616,442129,248052,225219,181833,140278,37423,527171,559229,173674,261848,48457,695786,689368,1039038,387794,145778,689455,743980,727047,340888,578538,195682,1025487,592566,128540,202246,51013,539601,1018866,607326,938218,954826,823307,447503,913092,53457,782228,395483,888332,954622,242728,219979,1017018,406132,948683,698508,990945,390823,1023439,851468,970746,739762,850140,140588,203832,203335,720643,208272,416621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497249 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000743s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497249 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]