SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002062s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397303 LIMIT 1 [ RunTime:0.000504s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397303 [ RunTime:0.003313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (814440,880372,589990,757498,291004,1008075,567606,208146,47255,1042792,425540,557742,472809,443759,868112,555095,315718,633121,977673,484658,625526,614384,834207,381797,957220,885429,173389,998810,706749,409562,953657,582944,853523,589846,314616,28609,699499,419827,500523,179783,580004,376637,884736,311124,424482,371370,912070,885452,765711,23821,733898,331537,165995,923170,342663,563327,159041,166256,556774,1003849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000622s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]