SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 149909 LIMIT 1 [ RunTime:0.001082s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 149909 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037441,851512,431722,556349,388025,652319,876702,321328,28144,827267,583373,253593,738096,402358,608066,535952,207736,185181,77429,739843,174743,638944,988265,999305,635047,752723,404222,454199,1043490,686821,249087,734073,342527,143859,580767,914781,768325,718999,910980,74980,187576,320341,236171,144878,315909,830163,979549,168177,181406,32471,1020149,148772,1029707,113101,610614,640230,379703,112992,551803,133871) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.032889s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 149909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 149909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002422s ]