SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 745196 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 745196 [ RunTime:0.001534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (48668,1043139,667013,260108,462711,281147,151257,292222,888671,1046618,356755,1048513,941621,853506,493602,429561,1031414,78146,155911,926910,184439,329381,1018397,396561,562224,647120,962138,478654,461476,815911,541719,168740,236113,288897,65675,533354,785694,77908,893400,74254,650781,547878,1004088,591687,500683,347278,626629,665343,5476,906227,179445,725555,281389,606906,915127,889736,816553,964226,165211,706273) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 745196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 745196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]