SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499049 LIMIT 1 [ RunTime:0.003450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499049 [ RunTime:0.002004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618829,334603,862355,614397,810418,41626,1007442,6936,544944,171780,730710,940889,694787,284593,735578,185267,372259,267168,773156,747726,115888,352674,130544,489140,673253,110805,29136,889085,295518,47810,638647,402216,272787,338364,504611,753971,52655,958574,906548,238569,737831,576627,533552,16424,1014742,561131,695484,625291,460203,426707,643024,360108,786313,100953,536641,367023,22645,837874,928588,212534) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001917s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499049 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499049 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]