SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470892 LIMIT 1 [ RunTime:0.000282s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470892 [ RunTime:0.001958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (139590,29468,352743,788880,233985,323573,92506,340616,461388,313135,992212,470526,93030,1045306,813834,837319,1036410,532799,441363,15305,660639,407516,323536,700042,379099,163060,749555,796849,874536,760267,876837,16820,677551,130285,672951,904073,242248,435255,407776,745764,1045460,356323,989318,328655,318288,271709,273045,225159,312243,474559,162132,782096,1035499,821283,668005,866181,656349,411045,90801,358358) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470892 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470892 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]