SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 571813 LIMIT 1 [ RunTime:0.000552s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 571813 [ RunTime:0.003465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939073,60506,287627,799865,608677,1018027,309936,773733,369026,595257,659133,972949,403133,872542,740150,332477,874358,880184,269132,113044,166188,866587,428047,989148,312033,951590,302808,183303,847340,829224,107299,599635,244909,313134,575803,125355,437702,616331,494100,319454,220422,375808,525384,961759,375740,955584,978976,178169,421212,113491,807310,485343,311025,969970,41171,813557,858286,479137,910039,306265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 571813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 571813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]