SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467257 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467257 [ RunTime:0.001882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (889312,700814,61990,28715,616135,968887,653178,725778,230855,438694,19174,532919,260111,429307,956396,501511,377254,194844,108892,621052,161639,521668,177487,125412,41356,550626,956650,580515,37717,522039,116501,425086,925631,734987,230915,374392,925915,125099,177238,296007,37785,1011310,128356,835565,877280,869349,379797,38649,8843,744402,835150,711826,806769,678436,747954,258378,758618,359647,733983,476447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467257 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467257 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]