SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048443 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048443 [ RunTime:0.002357s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (624836,661712,370205,641508,929779,117596,49333,526148,341042,140055,19361,576928,232309,419876,95328,1030527,455972,770728,765266,269008,371904,1044382,484428,126508,609253,561092,910070,1002,942571,947935,642107,181016,763990,15111,753755,282461,734939,668637,826209,126769,880426,952240,865327,14988,324210,411920,290069,375532,409903,755192,796288,517534,156952,312393,690564,39201,684673,1010480,213972,798191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]