SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343845 LIMIT 1 [ RunTime:0.000502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343845 [ RunTime:0.002084s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378693,455219,772566,204508,183844,305163,111911,988109,43165,418710,12991,433737,967692,1034806,905711,176807,1034458,994161,904393,634748,557735,419006,60551,365463,924029,830852,836478,1048364,558059,347729,515988,18981,308195,652619,743150,174075,742828,3541,645458,517644,612020,327967,1013365,121332,479863,429774,814730,286977,821140,968655,267336,197274,855261,617651,530307,987724,846324,641514,775229,910641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000907s ]