SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514750 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514750 [ RunTime:0.001981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018583,715893,465182,840204,779376,31088,893976,342783,31520,655161,176938,942284,745697,226856,758521,508675,593191,442384,278729,271189,387255,1032130,572363,375060,462978,826872,513760,614855,801018,97223,131620,13025,150671,721460,389005,896602,503429,359291,784120,680133,151957,924618,73321,382619,750036,157839,359450,764563,299056,67144,13796,298085,1013489,668596,343909,938003,932439,343296,1008494,226133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514750 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514750 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004505s ]