SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 969947 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 969947 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (338060,178001,179119,282281,654033,356156,524760,379066,894437,40074,895101,265300,679151,849751,24609,991800,105102,932913,320047,735737,444186,904483,305351,510611,385726,528878,897676,553855,775496,671284,95086,78501,622715,765873,966108,962375,1041430,601798,45054,291839,365219,574505,584394,715386,582756,858950,705111,957980,623994,74489,527191,977474,231897,679093,117089,252980,142737,75568,765947,295564) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001810s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 969947 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 969947 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]