SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019973 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019973 [ RunTime:0.001647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337454,939721,873648,187219,308233,374313,212582,838760,1026494,254315,876996,706912,689954,799885,598645,558640,897308,585943,241142,832082,376842,866070,611959,425221,423956,606451,365368,1030315,886172,881327,356616,862518,1020957,19461,90361,8297,659944,861978,55607,989401,160884,943197,418975,741965,711194,911438,221101,762519,333176,75053,651773,748711,680243,1025876,127283,933339,129791,422702,83253,786569) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019973 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019973 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]