SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502996 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502996 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (740567,160444,710404,88921,1022403,931855,125635,921131,321214,383587,181154,396941,150046,89697,579835,792445,913821,794049,804909,61905,680911,972025,909884,199084,513185,143372,147464,495633,433886,517162,523357,209062,557186,232841,91717,372460,581977,532344,840559,285436,802967,990259,559704,904378,588860,919358,808424,753037,807712,595483,308359,740135,818671,147986,758423,23097,712186,874336,346264,91925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502996 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502996 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001155s ]