SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538504 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538504 [ RunTime:0.002197s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (718614,495621,664633,669340,930152,355753,279215,442482,478742,282545,116385,638400,285849,471216,884224,715354,847093,836314,134239,46096,150455,87088,38897,713270,344302,431336,833227,716856,603782,513479,605263,430383,165433,1046252,364858,787930,732277,688356,324442,763394,3696,484185,376643,722045,829279,369135,758849,701124,507589,204844,19074,985682,250423,854658,440586,686450,322813,577357,285385,855550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000379s ]