SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419834 LIMIT 1 [ RunTime:0.000500s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419834 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42988,876364,856626,1010644,226174,675172,428899,976079,511827,288259,443660,200889,47619,459631,11117,37532,837662,457909,811301,334663,141034,411455,464997,599631,158186,20443,943681,722161,298021,679519,162102,334924,363951,701794,51091,309266,374254,315784,486192,724570,811890,99862,151265,273557,911588,1029052,811000,26641,477017,1021125,1003359,960163,578500,277095,201961,259388,82207,226305,412382,636676) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001737s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000686s ]