SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319989 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319989 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563813,501513,654298,268107,373913,457620,773711,793341,811200,169903,604948,120339,258031,258074,99965,651953,905076,40651,438608,313954,375215,269576,161888,935572,855574,892993,243230,651262,322813,597,812707,574583,379256,128111,765502,70027,309432,546609,727338,315343,519151,822912,957305,174688,190424,112156,958153,612266,238964,891599,45501,389292,608863,215006,184917,767066,941096,961314,1008795,901976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319989 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319989 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]