SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535415 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535415 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422768,255245,247703,467525,806206,452559,170210,270118,542741,29513,940041,486829,532376,740290,444000,509789,21578,92942,183592,1042351,161856,73488,899382,1012617,572652,503824,969486,1046585,1011811,653785,898867,945170,404943,722994,1040774,858116,639832,214503,17636,164724,341741,737144,891598,99668,148085,289132,979733,117513,368545,279714,930924,906069,260763,95858,163068,397592,865624,802997,829433,702021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]