SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001885s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040404 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040404 [ RunTime:0.001841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262754,130240,13664,641053,480583,21352,390202,691853,1010677,732406,923965,419963,821141,975922,493998,11221,506687,970281,305012,260390,897905,733986,870262,361931,488221,673810,715268,987341,683756,253222,899046,236177,766031,356666,667531,37861,297402,528166,557095,743286,942889,978364,208430,59486,413709,839083,18794,475189,375196,630637,853280,830614,652752,200049,620275,220940,484990,742895,502551,700717) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]