SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517501 LIMIT 1 [ RunTime:0.001170s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517501 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816555,199815,801138,875164,847851,580820,827376,204176,830970,349975,917668,387645,33272,422271,68599,185793,669148,73208,85744,231866,655991,235389,30926,2056,431059,171626,344942,576726,697983,65965,73894,875311,562459,600035,969542,663035,589314,233121,398502,196771,809282,930021,713666,201899,949982,170083,846485,729917,792587,859089,765393,805633,884728,942709,670431,514118,300783,844795,699257,617328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001022s ]