SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194894 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194894 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100900,806476,580348,623578,274753,433384,286266,662831,597420,614187,333180,474063,165712,603632,320062,92802,500274,527072,826201,238816,873746,925356,3087,603094,743642,146130,451862,527449,109335,126351,238132,819232,147829,1020582,356263,97126,892995,760536,524373,906379,327087,153728,767836,439955,550388,34425,293193,373027,798330,521502,774577,584150,779668,702234,633523,113867,155101,706741,621309,1024202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000826s ]