SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036507 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036507 [ RunTime:0.001832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001368,357784,127237,526535,75784,424625,475172,102766,573693,435604,231015,439832,406614,594862,17735,535622,836509,712840,255484,23832,54242,213463,388533,1029559,693585,55577,352636,77699,216287,321796,371610,642486,605756,969743,220159,778796,709737,415915,466910,175425,546252,101794,642892,60356,45612,934073,271507,734530,261817,472804,940719,451603,517297,86896,490056,782953,779564,914943,473792,553752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036507 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036507 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]