SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403819 LIMIT 1 [ RunTime:0.000527s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403819 [ RunTime:0.001594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (448995,755011,794581,771973,283125,123045,949350,140980,276684,700810,533410,310302,561417,985984,662058,478934,38282,391890,643633,546312,604687,594316,121489,544524,207170,508003,60325,672370,911343,449638,962788,264315,715149,867500,390778,546435,590212,1022593,287572,559867,729237,908512,527982,203637,642377,887010,485562,91403,735246,857277,939436,5085,281620,502663,623366,819923,1001670,50815,500454,432864) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403819 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403819 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]