SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001556s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580383 LIMIT 1 [ RunTime:0.001325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580383 [ RunTime:0.002446s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42198,863312,261947,1024191,511539,895084,317411,920051,384073,103564,731729,566902,836530,596198,654322,767517,232626,1030009,572334,859283,55676,782672,252981,450161,147043,611292,790124,382901,584732,236650,146940,725988,183574,1015181,861513,663414,261697,620396,39647,337618,734049,840218,1047080,486681,776656,799759,377399,416442,171927,497683,391337,567885,877645,3006,563007,231952,806180,780543,1035504,644853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002628s ]