SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029128 LIMIT 1 [ RunTime:0.000672s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029128 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902203,620883,298555,489664,891108,882898,285907,306694,215040,894324,347855,858436,834620,165309,222851,668044,186527,543270,354878,47354,130282,975820,301340,661312,720236,146825,227457,821112,805518,273501,163221,366939,318685,573649,272334,533782,236776,923101,854231,235569,203403,286274,809175,142066,731549,464881,1003588,395389,854799,77841,588292,65257,80082,381823,151732,1008050,525404,3419,811979,569083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029128 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029128 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]