SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004970s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471414 LIMIT 1 [ RunTime:0.000536s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471414 [ RunTime:0.008730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (653914,356033,458978,146521,892973,414591,886589,984073,879894,72427,932488,876844,873568,270501,381508,105108,1013316,960483,430298,618570,590055,997543,961917,264113,150517,131206,1001116,581275,1011170,146778,265594,931348,532315,93651,850331,664485,825574,592465,702304,285571,607763,84559,779110,182658,102926,702210,930974,581567,894656,991384,185876,851799,366203,419755,401793,1021101,732033,359803,727812,871096) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001190s ]