SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001466s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495699 LIMIT 1 [ RunTime:0.001074s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495699 [ RunTime:0.001789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293618,439779,848240,1027447,401812,762860,239958,125393,250450,13626,940700,28263,1006143,986874,18658,393077,556129,897093,334713,936929,113531,568407,542102,81540,993504,157009,941709,87565,362590,244160,225787,837869,774882,911269,1001377,608912,681174,600426,1025896,33336,758175,845212,769049,96144,490157,843263,605025,716798,750767,124077,490397,763017,281875,377702,175543,277338,980902,337396,497640,681388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]