SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28561 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28561 [ RunTime:0.001805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262467,970752,778817,556828,260361,473344,268034,128747,945820,929620,386321,580772,452867,662092,1035512,545345,502062,423642,560687,162639,856547,504467,630069,383175,823892,434071,81827,405681,86376,228359,190483,981150,313219,548866,440786,862639,979904,638398,539814,68052,173622,119449,818778,1015066,836397,793994,383816,661149,288840,898088,305073,882883,15850,550659,185304,487856,178232,1023622,457373,721269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28561 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28561 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]