SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003147 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003147 [ RunTime:0.002115s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018234,452243,185270,426241,318080,590268,624959,654804,406596,620140,940800,321583,859245,180220,862180,815010,35341,55053,35913,310279,702981,428471,210254,405629,488692,691312,705824,211947,195393,937738,328437,729657,174938,47758,666636,422970,491631,580370,22632,121017,30987,798795,369482,544084,989109,198794,1034331,964344,151421,390218,582185,734219,987588,920995,719895,874265,279743,740054,927619,688923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003147 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003147 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]