SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535817 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535817 [ RunTime:0.003012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109150,151906,984602,66464,125854,107095,150987,694906,533744,899836,881601,216071,784417,401158,418482,377910,900918,883935,187953,436305,665455,999094,496968,505100,548309,512444,592670,243464,230733,533691,701621,20924,1035394,953776,978779,837969,461199,213447,831414,509884,177357,216010,824139,878965,808353,66819,578893,62199,290501,677131,497327,289577,95077,562079,586340,95629,108501,991682,854691,844395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]