SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003923s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293513 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293513 [ RunTime:0.004311s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (190723,337839,795045,437564,549699,711186,1045667,724869,779935,484756,245642,934190,867664,463644,1041737,466506,558102,59233,890522,721440,692967,425530,1003731,121706,565184,877466,97965,70170,905143,497858,937027,710320,597616,383886,605528,902099,1042266,91138,969312,593307,197500,261656,238651,645920,457922,709985,910433,164195,877896,871409,638989,523128,209950,736128,767674,651857,555133,518961,556052,163065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]