SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508487 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508487 [ RunTime:0.001380s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (594984,1012622,789271,940303,168702,189664,588608,842456,1019638,587321,299969,184076,19221,253499,256292,27052,1006607,365624,203920,238632,857799,471581,857571,409936,977810,2835,568835,168595,337470,271380,283189,640647,847730,830721,800183,1001486,403234,364196,727325,869136,154454,992604,512208,845174,968729,94279,916560,390007,77226,190534,554289,450813,311163,260917,841763,158284,382636,184548,22915,116762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508487 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508487 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]