SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001966s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193994 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193994 [ RunTime:0.003232s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144529,857576,831091,622011,723859,882467,300015,141668,663511,482304,609143,569457,110724,75505,595821,104514,369718,470273,39108,107440,287517,141762,789181,642549,920198,293029,222559,813824,12534,930158,726807,869856,440770,756693,608689,99502,676978,424040,142550,406030,716519,447918,472505,976524,634276,422627,908158,989913,861756,93854,566832,430075,43027,749251,607121,722904,910475,674164,562328,310586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193994 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193994 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]