SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194044 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194044 [ RunTime:0.002732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197210,12878,124358,641536,44049,118084,760866,723812,56731,995475,626805,747887,818498,825775,322848,191895,55217,435668,255568,632100,420700,487309,36866,531920,290126,350284,777653,551574,932124,971865,827933,763104,514228,666589,919822,359795,474964,682121,744452,958705,636533,336188,403338,707069,351250,1002745,1044752,146904,65790,73788,611438,42044,584294,472949,814631,288594,502489,347357,368374,715738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194044 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194044 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]