SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335004 LIMIT 1 [ RunTime:0.000860s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335004 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500714,387089,603078,477835,138096,1003868,341291,469762,525590,535057,1044965,683211,598918,690483,649193,603123,258940,773618,228415,820060,300555,858333,993667,649254,787786,128018,673221,851981,262343,417925,365642,253622,662639,630139,94950,967530,832502,661445,17625,452289,715624,698588,925008,885258,772167,933625,155347,139040,968299,765604,9741,647660,247768,789609,687869,987148,730296,656990,371116,869641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]