SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003424s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045055 LIMIT 1 [ RunTime:0.008569s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045055 [ RunTime:0.010198s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (991244,471871,1026176,792465,677445,309920,79958,873312,47686,34381,382464,904597,60801,527078,545620,395465,666782,383440,144714,338637,485829,82181,115670,810218,631513,420107,770224,245441,66209,144616,350782,930574,657817,4220,56109,1003302,545098,915040,178003,230685,749250,176682,784178,872149,21066,113741,457770,90594,988038,847025,500406,501901,656577,116997,567303,678685,1026579,634727,540756,972579) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045055 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006748s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045055 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000822s ]