SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196441 LIMIT 1 [ RunTime:0.000481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196441 [ RunTime:0.002098s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (346680,927288,383416,950291,180251,403686,488043,916430,100804,479565,163596,620467,846873,107241,321835,214340,643843,340094,132489,495994,784189,854413,381592,706125,877565,300869,1036454,547605,734115,459563,724729,653888,589516,794679,684197,229858,845113,1026385,358216,1032792,1005607,674302,162642,499684,422448,1025152,657050,165740,816540,357943,511250,810917,240163,527420,111418,789167,119573,176712,733085,680218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]