SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002944s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414242 LIMIT 1 [ RunTime:0.002197s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414242 [ RunTime:0.004874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (720253,210525,1016623,80151,576954,674542,812386,306115,509375,407249,934412,97774,816924,276991,662891,668473,365404,214180,690796,730595,351761,529065,240319,936640,121201,1010736,877571,994365,488436,722968,650254,965038,89299,73287,536000,100915,470554,663283,654122,854164,434599,256017,620284,773682,60198,187717,15227,190583,206349,669151,953511,1007388,208308,385699,766661,453797,254176,527928,69645,31663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414242 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414242 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]