SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001839s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429123 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429123 [ RunTime:0.003287s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (792912,126633,85161,189911,504913,210848,239192,652160,192431,815708,1017453,389640,469774,479724,694729,633503,262327,1034063,31000,547455,999376,859457,915843,942937,588651,919898,320520,498502,570612,514045,235383,923860,1027828,586193,97900,656710,924730,471706,430180,987946,649175,859846,176884,172307,318789,397703,397125,169842,17025,1019198,914540,568593,868025,27409,558782,361972,372200,857136,369859,956342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429123 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429123 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]